package com.ym.excel.utils;

import com.ym.excel.model.YMChartModel;

import java.util.List;

/**
 * @Author: smuswc
 * @Date: 2018/2/7 16:21
 * @Description:
 */
public interface ExcelChartOperatorInte {

    String writeExcelWithChart(List<List<String>> data, YMChartModel chartModel) throws Exception;

    String writeExcelWithChart(String path, List<List<String>> data, YMChartModel chartModel) throws Exception;

    String writeExcelWithChart(String path, String fileName, List<List<String>> data, YMChartModel chartModel) throws Exception;

    String writeExcelWithChart(String path, String fileName, String sheetName, List<List<String>> data, YMChartModel chartModel) throws Exception;

    String writeExcelWithChart(String path, String fileName, String sheetName, List<String> title, List<List<String>> data, YMChartModel chartModel) throws Exception;

    /**
     * 生成Excel 附带 统计图
     * @param path
     * @param fileName
     * @param sheetName
     * @param title
     * @param data
     * @param hideColumn
     * @param chartModel
     * @return
     * @throws Exception
     */
    String writeExcelWithChart(String path, String fileName, String sheetName, List<String> title, List<List<String>> data, Integer[] hideColumn, YMChartModel chartModel) throws Exception;

    /**
     * 为以存在的Excel 添加 统计图
     * @param excelPath
     * @param sheetName
     * @param chartModel
     * @return
     * @throws Exception
     */
    String writeChartToExcel(String excelPath, String sheetName, YMChartModel chartModel) throws Exception;
}
